Labels:bulletin board | chat room | hakham | monitor | sky | stairs OCR: 652 SECTION D CHAPTER 11 When joining two tables, the convention is to use the full specification for FIGURE 11-51 table and field name Figure 11-51 dissects an SQL query that joins two The JOIN command links the Vintage Music Shop tables. Albums and Tracks tables to produce the album name cover, price and tracks for item number LPM-2256. SELECT Albums AlbumTitle The SELECT clause specifies the fields that should appear Albums Album Title refers to Albums Album Cover the Album Title field of the Albums table Albums DiscountPrice Tracks TrackTitle The JOIN command links the FROM Albums JOIN Tracks on Albums and Tracks tables Albums Cat# Tracks Cat# The in the tables Cat# are fields joined of records when the from same the two data tables appears WHERE Album Cat# LPM -2256 The WHERE clause s ...
